using System;
using System.ComponentModel;
using System.Data;
using System.Runtime.Serialization;
namespace DataAccess
{
    /// <summary>
    /// A custom serializable dataset containing SIG_PLAN_PROGRAMA information.
    /// </summary>
    [Serializable]
    [DesignerCategory("code")]
    public class SigPlanProgramaData : DataTable
    {
        ///
        /// Constants for table and fields mapping
        ///
        public const String SIG_PLAN_PROGRAMA_TABLE = "SIG_PLAN_PROGRAMA";
        public const String SPZ_ID_FIELD = "SPZ_ID";
        public const String PRG_ID_FIELD = "PRG_ID";
        public const String PRG_NOMBRE_FIELD = "PRG_NOMBRE";
        public const String DEP_ID_FIELD = "DEP_ID";
        public const String GPR_ID_FIELD = "GPR_ID";

        ////SIG_PROGRAMAS_BAS_ZONAS_GEOGRAFICAS
        //public const String PRG_CANTIDAD_FIELD = "PRG_CANTIDAD";
        //public const String PRG_DESCRIPCION_FIELD = "PRG_DESCRIPCION";
        //public const String PRG_ANO_FIELD = "PRG_ANO";
        //public const String PRG_OBSERVACIONES_FIELD = "PRG_OBSERVACIONES";
        //public const String PRG_VALOR_EJECUCION_FIELD = "PRG_VALOR_EJECUCION";
        //public const String PRG_POBLACION_BENEFICIADA_FIELD = "PRG_POBLACION_BENEFICIADA";
        //public const String ZON_ID_FIELD = "ZON_ID";
        //public const String RES_ID_FIELD = "RES_ID";


        ////BAS_ZONAS_GEOGRAFICAS
        //public const String ZON_NOMBRE_FIELD = "ZON_NOMBRE";

        ////BAS_RESGUARDOS
        //public const String RES_NOMBRE_FIELD = "RES_NOMBRE";

        ////SIG_IMAGENES_PROGRAMAS
        //public const String SIP_NOMBRE_FIELD = "SIP_NOMBRE";


        ////SIG_GRUPO_PROGRAMAS
        //public const String GPR_NOMBRE_FIELD = "GPR_NOMBRE";

        public SigPlanProgramaData()
		{
			BuildDataTables();
		}
        protected SigPlanProgramaData(SerializationInfo info, StreamingContext context)
		{
			//
		}
        /// <summary>
		/// 
		/// </summary>
		private void BuildDataTables()
		{

            Columns.Add(SPZ_ID_FIELD, typeof(Decimal));
            Columns.Add(PRG_ID_FIELD, typeof(String));
            Columns.Add(PRG_NOMBRE_FIELD, typeof(String));
            Columns.Add(DEP_ID_FIELD, typeof(String));
            Columns.Add(GPR_ID_FIELD, typeof(String));


            //Columns.Add(PRG_CANTIDAD_FIELD, typeof(Decimal));
            //Columns.Add(PRG_DESCRIPCION_FIELD, typeof(String));
            //Columns.Add(PRG_ANO_FIELD, typeof(String));
            //Columns.Add(PRG_OBSERVACIONES_FIELD, typeof(String));
            //Columns.Add(PRG_VALOR_EJECUCION_FIELD, typeof(Decimal));
            //Columns.Add(PRG_POBLACION_BENEFICIADA_FIELD, typeof(Decimal));
            //Columns.Add(ZON_ID_FIELD, typeof(String));
            //Columns.Add(RES_ID_FIELD, typeof(String));
                
            //Columns.Add(ZON_NOMBRE_FIELD, typeof(String));
            //Columns.Add(RES_NOMBRE_FIELD, typeof(String));


            //Columns.Add(SIP_NOMBRE_FIELD, typeof(String));
            //Columns.Add(GPR_NOMBRE_FIELD, typeof(String));

            TableName = SIG_PLAN_PROGRAMA_TABLE;
		}

        /// <summary>
        /// 
        /// </summary>
        /// <param name="row"></param>
        public void Add(DataRow row)
        {
            Rows.Add(row);
        }
    }
}
